NTISthis.com

Evidence Guide: CPPSEC3021A - Maintain and use security database

Student: __________________________________________________

Signature: _________________________________________________

Tips for gathering evidence to demonstrate your skills

The important thing to remember when gathering evidence is that the more evidence the better - that is, the more evidence you gather to demonstrate your skills, the more confident an assessor can be that you have learned the skills not just at one point in time, but are continuing to apply and develop those skills (as opposed to just learning for the test!). Furthermore, one piece of evidence that you collect will not usualy demonstrate all the required criteria for a unit of competency, whereas multiple overlapping pieces of evidence will usually do the trick!

From the Wiki University

 

CPPSEC3021A - Maintain and use security database

What evidence can you provide to prove your understanding of each of the following citeria?

Prepare to use security database.

  1. Applicable provisions of legislative and organisational requirements relevant to operating a security database are identified and complied with.
  2. Ergonomic and conservation issues are identified and appropriate risk control measures implemented in accordance with Occupational Health and Safety (OHS) guidelines.
  3. Appropriate software and hardware is identified to meet task requirements and installed in accordance with manufacturer's instructions.
  4. Virus protection is monitored, maintained regularly updated to ensure the continuous integrity and protection of data.
  5. Database storage, security and access requirements are identified and complied with to ensure the confidentiality and security of data.
  6. Established housekeeping, maintenance and back-up procedures are identified and conducted on a routine basis.
  7. Stand-by database and alternative strategies are identified and implemented as required to address operational faults and deficiencies in database systems.
Applicable provisions of legislative and organisational requirements relevant to operating a security database are identified and complied with.

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Ergonomic and conservation issues are identified and appropriate risk control measures implemented in accordance with Occupational Health and Safety (OHS) guidelines.

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Appropriate software and hardware is identified to meet task requirements and installed in accordance with manufacturer's instructions.

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Virus protection is monitored, maintained regularly updated to ensure the continuous integrity and protection of data.

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Database storage, security and access requirements are identified and complied with to ensure the confidentiality and security of data.

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Established housekeeping, maintenance and back-up procedures are identified and conducted on a routine basis.

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Stand-by database and alternative strategies are identified and implemented as required to address operational faults and deficiencies in database systems.

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Use security database.

  1. Data entry, output and presentation requirements are identified and complied with in accordance with assignment instructions.
  2. Data is obtained from verifiable sources, checked and monitored for variations in data quality.
  3. Data is entered, checked for accuracy and updated as required.
  4. Errors and lags in data processing or discrepancies are identified, diagnosed and reported.
  5. Complex faults or repair requirements outside area of responsibility or competence are reported for specialist assistance.
  6. Measures to improve database content, interfaces or effectiveness are identified and confirmed with relevant persons.
Data entry, output and presentation requirements are identified and complied with in accordance with assignment instructions.

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Data is obtained from verifiable sources, checked and monitored for variations in data quality.

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Data is entered, checked for accuracy and updated as required.

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Errors and lags in data processing or discrepancies are identified, diagnosed and reported.

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Complex faults or repair requirements outside area of responsibility or competence are reported for specialist assistance.

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Measures to improve database content, interfaces or effectiveness are identified and confirmed with relevant persons.

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Compile reports.

  1. Reports are prepared in a timely manner using appropriate formats and presentation methods.
  2. Reports are produced using relevant data and are reviewed and checked for accuracy.
  3. Constructive feedback to improve and maintain security database systems is received and used to inform future practice.
  4. Procedures for the safe storage and protection of data are identified and complied with in accordance with organisational procedures.
  5. Relevant documentation is completed and securely maintained with due regard to confidentiality in accordance with organisational procedures.
Reports are prepared in a timely manner using appropriate formats and presentation methods.

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Reports are produced using relevant data and are reviewed and checked for accuracy.

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Constructive feedback to improve and maintain security database systems is received and used to inform future practice.

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Procedures for the safe storage and protection of data are identified and complied with in accordance with organisational procedures.

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Relevant documentation is completed and securely maintained with due regard to confidentiality in accordance with organisational procedures.

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Assessed

Teacher: ___________________________________ Date: _________

Signature: ________________________________________________

Comments:

 

 

 

 

 

 

 

 

Instructions to Assessors

Evidence Guide

The evidence guide provides advice on assessment and must be read in conjunction with the performance criteria, required skills and knowledge, range statement and the Assessment Guidelines for the Training Package.

Critical aspects for assessment and evidence required to demonstrate competency in this unit

A person who demonstrates competency in this unit must be able to provide evidence of:

accurately diagnosing and rectifying errors and lags in data processing

implementing a broad application of database functions using accurate data inputting techniques to complete work tasks within designated timeframes

monitoring and reviewing database effectiveness and using constructive feedback to improve and maintain database systems.

producing reports in required formats in a timely manner and reviewing for accuracy, compatibility and reliability of data

using established storage, protection and backup procedures and security and access systems to maintain database effectiveness and data integrity.

Context of and specific resources for assessment

Context of assessment includes:

a setting in the workplace or environment that simulates the conditions of performance described in the elements, performance criteria and range statement.

Resource implications for assessment include:

access to plain English version of relevant statutes and procedures

access to a registered provider of assessment services

access to a suitable venue and equipment

assessment instruments including personal planner and assessment record book

work schedules, organisational policies and duty statements.

Reasonable adjustments must be made to assessment processes where required for people with disabilities. This could include access to modified equipment and other physical resources, and the provision of appropriate assessment support.

Method of assessment

This unit of competency could be assessed using the following methods of assessment:

observation of processes and procedures

questioning of underpinning knowledge and skills.

Guidance information for assessment

Assessment processes and techniques must be culturally appropriate and suitable to the language, literacy and numeracy capacity of the candidate and the competency being assessed. In all cases where practical assessment is used, it should be combined with targeted questioning to assess the underpinning knowledge.

Oral questioning or written assessment may be used to assess underpinning knowledge. In assessment situations where the candidate is offered a choice between oral questioning and written assessment, questions are to be identical.

Supplementary evidence may be obtained from relevant authenticated correspondence from existing supervisors, team leaders or specialist training staff.

Required Skills and Knowledge

This section describes the skills and knowledge and their level required for this unit.

Required skills

apply best practice in backup and recovery strategies

apply keyboarding skills to maintain data

apply safe and effective ergonomic workplace practices

collate and present data

conduct checks for accurate and consistent information

create simple queries using simple formulae

interpret and evaluate the purposes and uses of various features of databases

prepare reports for analysis and evaluation of information in a defined range of areas

read and interpret complex instructions and technical material

use processes flexibly and interchangeably to solve routine problems.

Required knowledge

backup and recovery methodologies

common database performance problems and solutions

data analysis techniques

data entry procedures and processes

database administration, security and storage requirements

database diagnostic tools and their functions

energy and resource conservation

OHS guidelines including ergonomic requirements

range of database software and hardware and their application

report and other documentation formats.

Range Statement

The range statement relates to the unit of competency as a whole. It allows for different work environments and situations that may affect performance. Bold italicised wording, if used in the performance criteria, is detailed below. Essential operating conditions that may be present with training and assessment (depending on the work situation, needs of the candidate, accessibility of the item, and local industry and regional contexts) may also be included.

Legislative requirements may relate to:

Australian standards and quality assurance requirements

counter-terrorism

crowd control and control of persons under the influence of intoxicating substances

force continuum, use of force guidelines

general 'duty of care' responsibilities

licensing or certification requirements

privacy and confidentiality

relevant commonwealth, state and territory legislation, codes and national standards for:

anti-discrimination

cultural and ethnic diversity

environmental issues

equal employment opportunity

industrial relations

OHS

relevant industry codes of practice

telecommunications

trespass and the removal of persons.

Organisational requirements may relate to:

access and equity policies, principles and practices

business and performance plans

client service standards

code of conduct, code of ethics

communication and reporting procedures

complaint and dispute resolution procedures

emergency and evacuation procedures

employer and employee rights and responsibilities

OHS policies, procedures and programs

own role, responsibility and authority

personal and professional development

privacy and confidentiality of information

quality assurance and continuous improvement processes and standards

resource parameters and procedures

roles, functions and responsibilities of security personnel

storage and disposal of information.

Ergonomic considerations may include:

avoiding radiation from computer screens

chair height, seat and back adjustment

document holder use

footrest use

lighting

noise minimisation

posture

rest periods and exercise breaks

screen, keyboard and mouse positions

work station height and layout.

Conservationtechniques may include:

recycling used and shredded paper

using of double sided paper

using re-used paper for drafts (observing confidentiality requirements)

utilising power-save options for equipment.

Security and accessprocedures may include:

data inputting

search and browse authorities

viewing and operation

write permission.

Back-up:

facilities range from a single tape unit to more comprehensive and complex backup facilities across the network.

Data entry, output and presentationprocedures include:

author's instructions

coding

data input

fault-finding

installation or de-installation of software or hardware

location and storage of data

log-on

password protection

standard formats

start-up or shutdown

troubleshooting

use of templates.

Sourcesmay include:

computer data files

government documents and registers

media reports

policy statements

statistical summaries

statutes.

Checksmay include:

consistency of data

ensuring accuracy of data

ensuring accuracy of formulae

ensuring instructions with regard to content and format have been followed filtering

proofreading

spelling.

Diagnosismay relate to:

hardware

input

output

running

software.

Relevant personsmay include:

clients

management

other professional or technical staff

security consultants

security personnel.

Feedbackmay include:

comments from management, colleagues or clients

formal and informal performance appraisals

personal, reflective behaviour strategies

workplace assessment.

Procedures for thestorage and protection of datamay relate to:

authorised access requirements

CD-ROM backup

maintaining hard copies

secure filing locations

storage (eg folders, sub-folders, hard drives, CDs, DVDs)

Documentationmay include:

costings

equipment faults and diagnosis

materials used, parts and components replaced

operational details

recommended repairs or disposal of equipment

repairs or servicing undertaken

testing and inspection results.